USE [Dosvid]
GO

/****** Object:  Trigger [dbo].[Candidates_UTrig]    Script Date: 09/10/2011 23:48:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



ALTER TRIGGER [dbo].[Candidates_UTrig] ON [dbo].[Candidates] AFTER UPDATE
AS 
BEGIN
  if @@rowcount = 0 return	 
  
  update c set
    c.DLC = convert(datetime,convert(varchar,getdate(),102))
  from Candidates c
  join inserted i on c.Id = i.Id
  join deleted d on d.Id = i.Id
  where (isnull(i.ApproveOnPost,-1) <> isnull(d.ApproveOnPost,-1) or
		 isnull(i.ManagerId,0) <> isnull(d.ManagerId,0) or
		 isnull(i.SexID,0) <> isnull(d.SexID,0) or
		 isnull(i.CarID,0) <> isnull(d.CarID,0) or
		 isnull(i.SalaryRangeID,0) <> isnull(d.SalaryRangeID,0) or
		 isnull(i.Position_CompareImportantID,0) <> isnull(d.Position_CompareImportantID,0) or
		 isnull(i.Territory_CompareImportantID,0) <> isnull(d.Territory_CompareImportantID,0) or
		 isnull(i.SalaryRange_CompareImportantID,0) <> isnull(d.SalaryRange_CompareImportantID,0) or
		 isnull(i.TerritoryID,0) <> isnull(d.TerritoryID,0) or
		 isnull(i.IsCandidate,-1) <> isnull(d.IsCandidate,-1) or
		 isnull(i.IsContactPerson,-1) <> isnull(d.IsContactPerson,-1) or
	     isnull(i.DocumentSum,0) <> isnull(d.DocumentSum,0) or
	     isnull(i.CandidateTypeId,0) <> isnull(d.CandidateTypeId,0) or
		 isnull(d.DateOfBirthDay,'1 jan 2000') <> isnull(i.DateOfBirthDay,'1 jan 2000') or
		 isnull(d.EnterDate,'1 jan 2000') <> isnull(i.EnterDate,'1 jan 2000') or
	     isnull(i.DocumnetNumber,'') <> isnull(d.DocumnetNumber,'') or
		 isnull(i.LastName,'') <> isnull(d.LastName,'') or
		 isnull(i.Adress,'') <> isnull(d.Adress,'') or
		 isnull(i.PrePaid,'') <> isnull(d.PrePaid,'') or
		 isnull(i.Education,'') <> isnull(d.Education,'') or
		 isnull(i.ResumeName,'') <> isnull(d.ResumeName,'') or
		 isnull(i.EducationType,'') <> isnull(d.EducationType,'') or
		 isnull(i.OnlyTradeMarks,'') <> isnull(d.OnlyTradeMarks,'') or
		 update(Characteristic) or
		 update(OtherReqirments) or
		 update(CommentForHistory)) and
		isnull(c.DLC,dateadd(day,-1,getdate())) <> convert(datetime,convert(varchar,getdate(),102))

end




GO


